Overview
Brought to you by YData
Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 45593 |
| Missing cells | 8903 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 23.4 MiB |
| Average record size in memory | 539.3 B |
Variable types
| Text | 1 |
|---|---|
| Numeric | 9 |
| DateTime | 2 |
| Categorical | 6 |
Delivery_location_latitude is highly overall correlated with translogi_latitude | High correlation |
Delivery_location_longitude is highly overall correlated with translogi_longitude | High correlation |
Delivery_person_Age is highly overall correlated with Vehicle_condition | High correlation |
Delivery_person_Ratings is highly overall correlated with Vehicle_condition | High correlation |
Road_traffic_density is highly overall correlated with Temperature and 1 other fields | High correlation |
Temperature is highly overall correlated with Road_traffic_density and 1 other fields | High correlation |
Time_taken is highly overall correlated with Traffic_Index | High correlation |
Traffic_Index is highly overall correlated with Road_traffic_density and 1 other fields | High correlation |
Vehicle_condition is highly overall correlated with Delivery_person_Age and 1 other fields | High correlation |
Weatherconditions is highly overall correlated with Temperature | High correlation |
translogi_latitude is highly overall correlated with Delivery_location_latitude | High correlation |
translogi_longitude is highly overall correlated with Delivery_location_longitude | High correlation |
Delivery_person_Age has 1854 (4.1%) missing values | Missing |
Delivery_person_Ratings has 1908 (4.2%) missing values | Missing |
Time_Orderd has 1731 (3.8%) missing values | Missing |
Weatherconditions has 616 (1.4%) missing values | Missing |
Road_traffic_density has 601 (1.3%) missing values | Missing |
multiple_deliveries has 993 (2.2%) missing values | Missing |
City has 1200 (2.6%) missing values | Missing |
ID has unique values | Unique |
translogi_latitude has 3640 (8.0%) zeros | Zeros |
translogi_longitude has 3640 (8.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-01-27 16:23:58.143946 |
|---|---|
| Analysis finished | 2025-01-27 16:24:11.775401 |
| Duration | 13.63 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
ID
Text
Unique
| Distinct | 45593 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.9457812 |
| Min length | 6 |
Unique
| Unique | 45593 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 0x4607 |
|---|---|
| 2nd row | 0xb379 |
| 3rd row | 0x5d6d |
| 4th row | 0x7a6a |
| 5th row | 0x70a2 |
| Value | Count | Frequency (%) |
| 0x4607 | 1 | < 0.1% |
| 0x36b8 | 1 | < 0.1% |
| 0xb816 | 1 | < 0.1% |
| 0x6c6b | 1 | < 0.1% |
| 0xd987 | 1 | < 0.1% |
| 0x5d6d | 1 | < 0.1% |
| 0x7a6a | 1 | < 0.1% |
| 0x70a2 | 1 | < 0.1% |
| 0x9bb4 | 1 | < 0.1% |
| 0x95b4 | 1 | < 0.1% |
| Other values (45583) | 45583 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 54129 | |
| x | 45593 | |
| 45593 | ||
| b | 11995 | 3.8% |
| 4 | 11890 | 3.8% |
| 7 | 11886 | 3.8% |
| 6 | 11874 | 3.7% |
| a | 11865 | 3.7% |
| 1 | 11824 | 3.7% |
| c | 11816 | 3.7% |
| Other values (8) | 88214 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 316679 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 54129 | |
| x | 45593 | |
| 45593 | ||
| b | 11995 | 3.8% |
| 4 | 11890 | 3.8% |
| 7 | 11886 | 3.8% |
| 6 | 11874 | 3.7% |
| a | 11865 | 3.7% |
| 1 | 11824 | 3.7% |
| c | 11816 | 3.7% |
| Other values (8) | 88214 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 316679 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 54129 | |
| x | 45593 | |
| 45593 | ||
| b | 11995 | 3.8% |
| 4 | 11890 | 3.8% |
| 7 | 11886 | 3.8% |
| 6 | 11874 | 3.7% |
| a | 11865 | 3.7% |
| 1 | 11824 | 3.7% |
| c | 11816 | 3.7% |
| Other values (8) | 88214 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 316679 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 54129 | |
| x | 45593 | |
| 45593 | ||
| b | 11995 | 3.8% |
| 4 | 11890 | 3.8% |
| 7 | 11886 | 3.8% |
| 6 | 11874 | 3.7% |
| a | 11865 | 3.7% |
| 1 | 11824 | 3.7% |
| c | 11816 | 3.7% |
| Other values (8) | 88214 |
Delivery_person_Age
Real number (ℝ)
High correlation Missing
| Distinct | 22 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1854 |
| Missing (%) | 4.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.567137 |
| Minimum | 15 |
|---|---|
| Maximum | 50 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 356.3 KiB |
Quantile statistics
| Minimum | 15 |
|---|---|
| 5-th percentile | 21 |
| Q1 | 25 |
| median | 30 |
| Q3 | 35 |
| 95-th percentile | 39 |
| Maximum | 50 |
| Range | 35 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 5.8151554 |
|---|---|
| Coefficient of variation (CV) | 0.19667631 |
| Kurtosis | -1.0583326 |
| Mean | 29.567137 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.018669335 |
| Sum | 1293237 |
| Variance | 33.816032 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=22)
| Value | Count | Frequency (%) |
| 35 | 2262 | 5.0% |
| 36 | 2260 | 5.0% |
| 37 | 2227 | 4.9% |
| 30 | 2226 | 4.9% |
| 38 | 2219 | 4.9% |
| 24 | 2210 | 4.8% |
| 32 | 2202 | 4.8% |
| 22 | 2196 | 4.8% |
| 29 | 2191 | 4.8% |
| 33 | 2187 | 4.8% |
| Other values (12) | 21559 |
| Value | Count | Frequency (%) |
| 15 | 38 | 0.1% |
| 20 | 2136 | |
| 21 | 2153 | |
| 22 | 2196 | |
| 23 | 2087 | |
| 24 | 2210 | |
| 25 | 2174 | |
| 26 | 2159 | |
| 27 | 2150 | |
| 28 | 2179 |
| Value | Count | Frequency (%) |
| 50 | 53 | 0.1% |
| 39 | 2144 | |
| 38 | 2219 | |
| 37 | 2227 | |
| 36 | 2260 | |
| 35 | 2262 | |
| 34 | 2166 | |
| 33 | 2187 | |
| 32 | 2202 | |
| 31 | 2120 |
Delivery_person_Ratings
Real number (ℝ)
High correlation Missing
| Distinct | 28 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1908 |
| Missing (%) | 4.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.6337805 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 356.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 4.5 |
| median | 4.7 |
| Q3 | 4.9 |
| 95-th percentile | 5 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 0.4 |
Descriptive statistics
| Standard deviation | 0.33471641 |
|---|---|
| Coefficient of variation (CV) | 0.07223398 |
| Kurtosis | 15.670705 |
| Mean | 4.6337805 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | -2.4935516 |
| Sum | 202426.7 |
| Variance | 0.11203507 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 4.8 | 7148 | |
| 4.7 | 7142 | |
| 4.9 | 7041 | |
| 4.6 | 6940 | |
| 5 | 3996 | |
| 4.5 | 3303 | |
| 4.1 | 1430 | 3.1% |
| 4.2 | 1418 | 3.1% |
| 4.3 | 1409 | 3.1% |
| 4.4 | 1361 | 3.0% |
| Other values (18) | 2497 | 5.5% |
| (Missing) | 1908 | 4.2% |
| Value | Count | Frequency (%) |
| 1 | 38 | |
| 2.5 | 20 | |
| 2.6 | 22 | |
| 2.7 | 22 | |
| 2.8 | 19 | |
| 2.9 | 19 | |
| 3 | 6 | < 0.1% |
| 3.1 | 29 | |
| 3.2 | 29 | |
| 3.3 | 25 |
| Value | Count | Frequency (%) |
| 6 | 53 | 0.1% |
| 5 | 3996 | |
| 4.9 | 7041 | |
| 4.8 | 7148 | |
| 4.7 | 7142 | |
| 4.6 | 6940 | |
| 4.5 | 3303 | |
| 4.4 | 1361 | 3.0% |
| 4.3 | 1409 | 3.1% |
| 4.2 | 1418 | 3.1% |
translogi_latitude
Real number (ℝ)
High correlation Zeros
| Distinct | 657 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.017729 |
| Minimum | -30.905562 |
|---|---|
| Maximum | 30.914057 |
| Zeros | 3640 |
| Zeros (%) | 8.0% |
| Negative | 431 |
| Negative (%) | 0.9% |
| Memory size | 356.3 KiB |
Quantile statistics
| Minimum | -30.905562 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 12.933284 |
| median | 18.546947 |
| Q3 | 22.728163 |
| 95-th percentile | 26.913987 |
| Maximum | 30.914057 |
| Range | 61.819619 |
| Interquartile range (IQR) | 9.794879 |
Descriptive statistics
| Standard deviation | 8.185109 |
|---|---|
| Coefficient of variation (CV) | 0.48097541 |
| Kurtosis | 3.713716 |
| Mean | 17.017729 |
| Median Absolute Deviation (MAD) | 5.482766 |
| Skewness | -1.3615831 |
| Sum | 775889.3 |
| Variance | 66.996009 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 3640 | 8.0% |
| 26.911378 | 182 | 0.4% |
| 26.914142 | 180 | 0.4% |
| 26.892312 | 176 | 0.4% |
| 26.90294 | 176 | 0.4% |
| 26.902908 | 176 | 0.4% |
| 26.88842 | 174 | 0.4% |
| 26.905287 | 173 | 0.4% |
| 26.913726 | 173 | 0.4% |
| 22.308096 | 172 | 0.4% |
| Other values (647) | 40371 |
| Value | Count | Frequency (%) |
| -30.905562 | 1 | < 0.1% |
| -30.902872 | 2 | |
| -30.899584 | 3 | |
| -30.895817 | 3 | |
| -30.893384 | 1 | < 0.1% |
| -30.893244 | 1 | < 0.1% |
| -30.892978 | 1 | < 0.1% |
| -30.890184 | 1 | < 0.1% |
| -30.885915 | 1 | < 0.1% |
| -30.885814 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 30.914057 | 42 | |
| 30.905562 | 37 | |
| 30.902872 | 32 | |
| 30.899992 | 38 | |
| 30.899584 | 41 | |
| 30.895817 | 36 | |
| 30.895204 | 41 | |
| 30.893384 | 38 | |
| 30.893244 | 38 | |
| 30.893234 | 39 |
translogi_longitude
Real number (ℝ)
High correlation Zeros
| Distinct | 518 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 70.231332 |
| Minimum | -88.366217 |
|---|---|
| Maximum | 88.433452 |
| Zeros | 3640 |
| Zeros (%) | 8.0% |
| Negative | 162 |
| Negative (%) | 0.4% |
| Memory size | 356.3 KiB |
Quantile statistics
| Minimum | -88.366217 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 73.17 |
| median | 75.898497 |
| Q3 | 78.044095 |
| 95-th percentile | 85.325347 |
| Maximum | 88.433452 |
| Range | 176.79967 |
| Interquartile range (IQR) | 4.874095 |
Descriptive statistics
| Standard deviation | 22.883647 |
|---|---|
| Coefficient of variation (CV) | 0.32583245 |
| Kurtosis | 10.303039 |
| Mean | 70.231332 |
| Median Absolute Deviation (MAD) | 2.161724 |
| Skewness | -3.2201594 |
| Sum | 3202057.1 |
| Variance | 523.66131 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 3640 | 8.0% |
| 75.789034 | 182 | 0.4% |
| 75.805704 | 181 | 0.4% |
| 75.793007 | 177 | 0.4% |
| 75.806896 | 176 | 0.4% |
| 75.792934 | 176 | 0.4% |
| 75.75282 | 174 | 0.4% |
| 75.800689 | 174 | 0.4% |
| 75.794592 | 173 | 0.4% |
| 73.167753 | 173 | 0.4% |
| Other values (508) | 40367 |
| Value | Count | Frequency (%) |
| -88.366217 | 1 | < 0.1% |
| -88.352885 | 1 | < 0.1% |
| -88.349843 | 1 | < 0.1% |
| -88.322337 | 1 | < 0.1% |
| -85.33982 | 1 | < 0.1% |
| -85.335486 | 1 | < 0.1% |
| -85.325731 | 3 | |
| -85.325447 | 2 | |
| -85.325146 | 1 | < 0.1% |
| -85.3172 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 88.433452 | 35 | |
| 88.433187 | 36 | |
| 88.400581 | 34 | |
| 88.400467 | 33 | |
| 88.39331 | 36 | |
| 88.393294 | 38 | |
| 88.368628 | 35 | |
| 88.36783 | 33 | |
| 88.366217 | 33 | |
| 88.365507 | 37 |
Delivery_location_latitude
Real number (ℝ)
High correlation
| Distinct | 4373 |
|---|---|
| Distinct (%) | 9.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.465186 |
| Minimum | 0.01 |
|---|---|
| Maximum | 31.054057 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 356.3 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.07 |
| Q1 | 12.988453 |
| median | 18.633934 |
| Q3 | 22.785049 |
| 95-th percentile | 27.023726 |
| Maximum | 31.054057 |
| Range | 31.044057 |
| Interquartile range (IQR) | 9.796596 |
Descriptive statistics
| Standard deviation | 7.335122 |
|---|---|
| Coefficient of variation (CV) | 0.41998534 |
| Kurtosis | 0.26434584 |
| Mean | 17.465186 |
| Median Absolute Deviation (MAD) | 5.47924 |
| Skewness | -0.70106646 |
| Sum | 796290.22 |
| Variance | 53.804015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.13 | 341 | 0.7% |
| 0.02 | 337 | 0.7% |
| 0.09 | 336 | 0.7% |
| 0.06 | 336 | 0.7% |
| 0.07 | 335 | 0.7% |
| 0.04 | 335 | 0.7% |
| 0.05 | 328 | 0.7% |
| 0.11 | 328 | 0.7% |
| 0.01 | 327 | 0.7% |
| 0.08 | 324 | 0.7% |
| Other values (4363) | 42266 |
| Value | Count | Frequency (%) |
| 0.01 | 327 | |
| 0.02 | 337 | |
| 0.03 | 313 | |
| 0.04 | 335 | |
| 0.05 | 328 | |
| 0.06 | 336 | |
| 0.07 | 335 | |
| 0.08 | 324 | |
| 0.09 | 336 | |
| 0.11 | 328 |
| Value | Count | Frequency (%) |
| 31.054057 | 3 | |
| 31.045562 | 4 | |
| 31.044057 | 4 | |
| 31.042872 | 2 | |
| 31.039992 | 3 | |
| 31.039584 | 4 | |
| 31.035817 | 4 | |
| 31.035562 | 3 | |
| 31.035204 | 4 | |
| 31.033384 | 4 |
Delivery_location_longitude
Real number (ℝ)
High correlation
| Distinct | 4373 |
|---|---|
| Distinct (%) | 9.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 70.845702 |
| Minimum | 0.01 |
|---|---|
| Maximum | 88.563452 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 356.3 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.07 |
| Q1 | 73.28 |
| median | 76.002574 |
| Q3 | 78.107044 |
| 95-th percentile | 85.375486 |
| Maximum | 88.563452 |
| Range | 88.553452 |
| Interquartile range (IQR) | 4.827044 |
Descriptive statistics
| Standard deviation | 21.118812 |
|---|---|
| Coefficient of variation (CV) | 0.29809588 |
| Kurtosis | 7.1044509 |
| Mean | 70.845702 |
| Median Absolute Deviation (MAD) | 2.196673 |
| Skewness | -2.9563849 |
| Sum | 3230068.1 |
| Variance | 446.00422 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.13 | 341 | 0.7% |
| 0.02 | 337 | 0.7% |
| 0.09 | 336 | 0.7% |
| 0.06 | 336 | 0.7% |
| 0.07 | 335 | 0.7% |
| 0.04 | 335 | 0.7% |
| 0.05 | 328 | 0.7% |
| 0.11 | 328 | 0.7% |
| 0.01 | 327 | 0.7% |
| 0.08 | 324 | 0.7% |
| Other values (4363) | 42266 |
| Value | Count | Frequency (%) |
| 0.01 | 327 | |
| 0.02 | 337 | |
| 0.03 | 313 | |
| 0.04 | 335 | |
| 0.05 | 328 | |
| 0.06 | 336 | |
| 0.07 | 335 | |
| 0.08 | 324 | |
| 0.09 | 336 | |
| 0.11 | 328 |
| Value | Count | Frequency (%) |
| 88.563452 | 2 | |
| 88.563187 | 4 | |
| 88.543452 | 3 | |
| 88.543187 | 4 | |
| 88.530581 | 4 | |
| 88.530467 | 3 | |
| 88.523452 | 4 | |
| 88.52331 | 4 | |
| 88.523294 | 2 | |
| 88.523187 | 2 |
Order_Date
Date
| Distinct | 44 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 356.3 KiB |
| Minimum | 2022-02-11 00:00:00 |
|---|---|
| Maximum | 2022-04-06 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=44)
Time_Orderd
Date
Missing
| Distinct | 176 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 1731 |
| Missing (%) | 3.8% |
| Memory size | 356.3 KiB |
| Minimum | 2025-01-27 00:00:00 |
|---|---|
| Maximum | 2025-01-27 23:55:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Weatherconditions
Categorical
High correlation Missing
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 616 |
| Missing (%) | 1.4% |
| Memory size | 2.7 MiB |
| Fog | |
|---|---|
| Stormy | |
| Cloudy | |
| Sandstorms | |
| Windy |
Length
| Max length | 10 |
|---|---|
| Median length | 6 |
| Mean length | 5.8290682 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Sunny |
|---|---|
| 2nd row | Stormy |
| 3rd row | Sandstorms |
| 4th row | Sunny |
| 5th row | Cloudy |
Common Values
| Value | Count | Frequency (%) |
| Fog | 7654 | |
| Stormy | 7586 | |
| Cloudy | 7536 | |
| Sandstorms | 7495 | |
| Windy | 7422 | |
| Sunny | 7284 | |
| (Missing) | 616 | 1.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| fog | 7654 | |
| stormy | 7586 | |
| cloudy | 7536 | |
| sandstorms | 7495 | |
| windy | 7422 | |
| sunny | 7284 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 30271 | |
| y | 29828 | |
| n | 29485 | |
| d | 22453 | |
| S | 22365 | |
| t | 15081 | 5.8% |
| r | 15081 | 5.8% |
| m | 15081 | 5.8% |
| s | 14990 | 5.7% |
| u | 14820 | 5.7% |
| Other values (7) | 52719 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 262174 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 30271 | |
| y | 29828 | |
| n | 29485 | |
| d | 22453 | |
| S | 22365 | |
| t | 15081 | 5.8% |
| r | 15081 | 5.8% |
| m | 15081 | 5.8% |
| s | 14990 | 5.7% |
| u | 14820 | 5.7% |
| Other values (7) | 52719 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 262174 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 30271 | |
| y | 29828 | |
| n | 29485 | |
| d | 22453 | |
| S | 22365 | |
| t | 15081 | 5.8% |
| r | 15081 | 5.8% |
| m | 15081 | 5.8% |
| s | 14990 | 5.7% |
| u | 14820 | 5.7% |
| Other values (7) | 52719 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 262174 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 30271 | |
| y | 29828 | |
| n | 29485 | |
| d | 22453 | |
| S | 22365 | |
| t | 15081 | 5.8% |
| r | 15081 | 5.8% |
| m | 15081 | 5.8% |
| s | 14990 | 5.7% |
| u | 14820 | 5.7% |
| Other values (7) | 52719 |
Road_traffic_density
Categorical
High correlation Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 601 |
| Missing (%) | 1.3% |
| Memory size | 2.6 MiB |
| Low | |
|---|---|
| Jam | |
| Medium | |
| High |
Length
| Max length | 6 |
|---|---|
| Median length | 3 |
| Mean length | 3.8282806 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | High |
|---|---|
| 2nd row | Jam |
| 3rd row | Low |
| 4th row | Medium |
| 5th row | High |
Common Values
| Value | Count | Frequency (%) |
| Low | 15477 | |
| Jam | 14143 | |
| Medium | 10947 | |
| High | 4425 | 9.7% |
| (Missing) | 601 | 1.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| low | 15477 | |
| jam | 14143 | |
| medium | 10947 | |
| high | 4425 | 9.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| m | 25090 | |
| L | 15477 | |
| o | 15477 | |
| w | 15477 | |
| i | 15372 | |
| J | 14143 | |
| a | 14143 | |
| M | 10947 | |
| e | 10947 | |
| d | 10947 | |
| Other values (4) | 24222 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 172242 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| m | 25090 | |
| L | 15477 | |
| o | 15477 | |
| w | 15477 | |
| i | 15372 | |
| J | 14143 | |
| a | 14143 | |
| M | 10947 | |
| e | 10947 | |
| d | 10947 | |
| Other values (4) | 24222 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 172242 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| m | 25090 | |
| L | 15477 | |
| o | 15477 | |
| w | 15477 | |
| i | 15372 | |
| J | 14143 | |
| a | 14143 | |
| M | 10947 | |
| e | 10947 | |
| d | 10947 | |
| Other values (4) | 24222 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 172242 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| m | 25090 | |
| L | 15477 | |
| o | 15477 | |
| w | 15477 | |
| i | 15372 | |
| J | 14143 | |
| a | 14143 | |
| M | 10947 | |
| e | 10947 | |
| d | 10947 | |
| Other values (4) | 24222 |
Vehicle_condition
Categorical
High correlation
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.5 MiB |
| 2 | |
|---|---|
| 1 | |
| 0 | |
| 3 | 520 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 15034 | |
| 1 | 15030 | |
| 0 | 15009 | |
| 3 | 520 | 1.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 15034 | |
| 1 | 15030 | |
| 0 | 15009 | |
| 3 | 520 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 15034 | |
| 1 | 15030 | |
| 0 | 15009 | |
| 3 | 520 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 45593 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 15034 | |
| 1 | 15030 | |
| 0 | 15009 | |
| 3 | 520 | 1.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 45593 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 15034 | |
| 1 | 15030 | |
| 0 | 15009 | |
| 3 | 520 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 45593 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 15034 | |
| 1 | 15030 | |
| 0 | 15009 | |
| 3 | 520 | 1.1% |
Type_of_vehicle
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| motorcycle | |
|---|---|
| scooter | |
| electric_scooter | |
| bicycle | 68 |
Length
| Max length | 16 |
|---|---|
| Median length | 10 |
| Mean length | 9.4922905 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | motorcycle |
|---|---|
| 2nd row | scooter |
| 3rd row | motorcycle |
| 4th row | motorcycle |
| 5th row | scooter |
Common Values
| Value | Count | Frequency (%) |
| motorcycle | 26435 | |
| scooter | 15276 | |
| electric_scooter | 3814 | 8.4% |
| bicycle | 68 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| motorcycle | 26435 | |
| scooter | 15276 | |
| electric_scooter | 3814 | 8.4% |
| bicycle | 68 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 91050 | |
| c | 79724 | |
| e | 53221 | |
| t | 49339 | |
| r | 49339 | |
| l | 30317 | 7.0% |
| y | 26503 | 6.1% |
| m | 26435 | 6.1% |
| s | 19090 | 4.4% |
| i | 3882 | 0.9% |
| Other values (2) | 3882 | 0.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 432782 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 91050 | |
| c | 79724 | |
| e | 53221 | |
| t | 49339 | |
| r | 49339 | |
| l | 30317 | 7.0% |
| y | 26503 | 6.1% |
| m | 26435 | 6.1% |
| s | 19090 | 4.4% |
| i | 3882 | 0.9% |
| Other values (2) | 3882 | 0.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 432782 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 91050 | |
| c | 79724 | |
| e | 53221 | |
| t | 49339 | |
| r | 49339 | |
| l | 30317 | 7.0% |
| y | 26503 | 6.1% |
| m | 26435 | 6.1% |
| s | 19090 | 4.4% |
| i | 3882 | 0.9% |
| Other values (2) | 3882 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 432782 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 91050 | |
| c | 79724 | |
| e | 53221 | |
| t | 49339 | |
| r | 49339 | |
| l | 30317 | 7.0% |
| y | 26503 | 6.1% |
| m | 26435 | 6.1% |
| s | 19090 | 4.4% |
| i | 3882 | 0.9% |
| Other values (2) | 3882 | 0.9% |
multiple_deliveries
Categorical
Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 993 |
| Missing (%) | 2.2% |
| Memory size | 2.6 MiB |
| 1.0 | |
|---|---|
| 0.0 | |
| 2.0 | 1985 |
| 3.0 | 361 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 28159 | |
| 0.0 | 14095 | |
| 2.0 | 1985 | 4.4% |
| 3.0 | 361 | 0.8% |
| (Missing) | 993 | 2.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 28159 | |
| 0.0 | 14095 | |
| 2.0 | 1985 | 4.5% |
| 3.0 | 361 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 58695 | |
| . | 44600 | |
| 1 | 28159 | |
| 2 | 1985 | 1.5% |
| 3 | 361 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 133800 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 58695 | |
| . | 44600 | |
| 1 | 28159 | |
| 2 | 1985 | 1.5% |
| 3 | 361 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 133800 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 58695 | |
| . | 44600 | |
| 1 | 28159 | |
| 2 | 1985 | 1.5% |
| 3 | 361 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 133800 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 58695 | |
| . | 44600 | |
| 1 | 28159 | |
| 2 | 1985 | 1.5% |
| 3 | 361 | 0.3% |
City
Categorical
Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1200 |
| Missing (%) | 2.6% |
| Memory size | 3.0 MiB |
| Metropolitian | |
|---|---|
| Urban | |
| Semi-Urban | 164 |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 11.162323 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Urban |
|---|---|
| 2nd row | Metropolitian |
| 3rd row | Urban |
| 4th row | Metropolitian |
| 5th row | Metropolitian |
Common Values
| Value | Count | Frequency (%) |
| Metropolitian | 34093 | |
| Urban | 10136 | 22.2% |
| Semi-Urban | 164 | 0.4% |
| (Missing) | 1200 | 2.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| metropolitian | 34093 | |
| urban | 10136 | 22.8% |
| semi-urban | 164 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 68350 | |
| t | 68186 | |
| o | 68186 | |
| r | 44393 | |
| a | 44393 | |
| n | 44393 | |
| e | 34257 | |
| M | 34093 | |
| p | 34093 | |
| l | 34093 | |
| Other values (5) | 21092 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 495529 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 68350 | |
| t | 68186 | |
| o | 68186 | |
| r | 44393 | |
| a | 44393 | |
| n | 44393 | |
| e | 34257 | |
| M | 34093 | |
| p | 34093 | |
| l | 34093 | |
| Other values (5) | 21092 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 495529 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 68350 | |
| t | 68186 | |
| o | 68186 | |
| r | 44393 | |
| a | 44393 | |
| n | 44393 | |
| e | 34257 | |
| M | 34093 | |
| p | 34093 | |
| l | 34093 | |
| Other values (5) | 21092 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 495529 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 68350 | |
| t | 68186 | |
| o | 68186 | |
| r | 44393 | |
| a | 44393 | |
| n | 44393 | |
| e | 34257 | |
| M | 34093 | |
| p | 34093 | |
| l | 34093 | |
| Other values (5) | 21092 | 4.3% |
Temperature
Real number (ℝ)
High correlation
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.57647 |
| Minimum | 16 |
|---|---|
| Maximum | 36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 356.3 KiB |
Quantile statistics
| Minimum | 16 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 20 |
| median | 23 |
| Q3 | 30 |
| 95-th percentile | 36 |
| Maximum | 36 |
| Range | 20 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 5.9805969 |
|---|---|
| Coefficient of variation (CV) | 0.24334646 |
| Kurtosis | -0.96419785 |
| Mean | 24.57647 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.49165885 |
| Sum | 1120515 |
| Variance | 35.767539 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=19)
| Value | Count | Frequency (%) |
| 23 | 5051 | 11.1% |
| 18 | 4203 | 9.2% |
| 20 | 4175 | 9.2% |
| 19 | 3332 | 7.3% |
| 21 | 3217 | 7.1% |
| 26 | 2613 | 5.7% |
| 36 | 2609 | 5.7% |
| 31 | 2475 | 5.4% |
| 25 | 2442 | 5.4% |
| 16 | 2429 | 5.3% |
| Other values (9) | 13047 |
| Value | Count | Frequency (%) |
| 16 | 2429 | |
| 17 | 776 | 1.7% |
| 18 | 4203 | |
| 19 | 3332 | |
| 20 | 4175 | |
| 21 | 3217 | |
| 22 | 1831 | 4.0% |
| 23 | 5051 | |
| 24 | 745 | 1.6% |
| 25 | 2442 |
| Value | Count | Frequency (%) |
| 36 | 2609 | |
| 35 | 1786 | |
| 34 | 701 | 1.5% |
| 33 | 2399 | |
| 31 | 2475 | |
| 30 | 1785 | |
| 29 | 735 | 1.6% |
| 28 | 2289 | |
| 26 | 2613 | |
| 25 | 2442 |
Traffic_Index
Real number (ℝ)
High correlation
| Distinct | 177 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4640672 |
| Minimum | 0.16666667 |
|---|---|
| Maximum | 6.5333333 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 356.3 KiB |
Quantile statistics
| Minimum | 0.16666667 |
|---|---|
| 5-th percentile | 0.28333333 |
| Q1 | 0.5 |
| median | 1.0666667 |
| Q3 | 2.0666667 |
| 95-th percentile | 3.8666667 |
| Maximum | 6.5333333 |
| Range | 6.3666667 |
| Interquartile range (IQR) | 1.5666667 |
Descriptive statistics
| Standard deviation | 1.2064471 |
|---|---|
| Coefficient of variation (CV) | 0.82403807 |
| Kurtosis | 1.8987782 |
| Mean | 1.4640672 |
| Median Absolute Deviation (MAD) | 0.66666667 |
| Skewness | 1.4066411 |
| Sum | 66751.217 |
| Variance | 1.4555147 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.4 | 966 | 2.1% |
| 0.3333333333 | 944 | 2.1% |
| 0.3666666667 | 919 | 2.0% |
| 0.5 | 761 | 1.7% |
| 1 | 754 | 1.7% |
| 0.4666666667 | 749 | 1.6% |
| 0.4333333333 | 737 | 1.6% |
| 0.6 | 725 | 1.6% |
| 0.8666666667 | 712 | 1.6% |
| 0.5666666667 | 686 | 1.5% |
| Other values (167) | 37640 |
| Value | Count | Frequency (%) |
| 0.1666666667 | 233 | 0.5% |
| 0.1833333333 | 221 | 0.5% |
| 0.2 | 221 | 0.5% |
| 0.2166666667 | 201 | 0.4% |
| 0.2222222222 | 7 | < 0.1% |
| 0.2333333333 | 237 | |
| 0.2444444444 | 8 | < 0.1% |
| 0.25 | 585 | |
| 0.2666666667 | 564 | |
| 0.2833333333 | 563 |
| Value | Count | Frequency (%) |
| 6.533333333 | 36 | 0.1% |
| 6.4 | 37 | 0.1% |
| 6.266666667 | 32 | 0.1% |
| 6.133333333 | 31 | 0.1% |
| 6 | 32 | 0.1% |
| 5.866666667 | 103 | |
| 5.733333333 | 116 | |
| 5.6 | 98 | |
| 5.466666667 | 120 | |
| 5.333333333 | 113 |
Time_taken
Real number (ℝ)
High correlation
| Distinct | 45 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.294607 |
| Minimum | 10 |
|---|---|
| Maximum | 54 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 356.3 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 19 |
| median | 26 |
| Q3 | 32 |
| 95-th percentile | 44 |
| Maximum | 54 |
| Range | 44 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 9.3838061 |
|---|---|
| Coefficient of variation (CV) | 0.3568719 |
| Kurtosis | -0.31079787 |
| Mean | 26.294607 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.48595123 |
| Sum | 1198850 |
| Variance | 88.055818 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=45)
| Value | Count | Frequency (%) |
| 26 | 2123 | 4.7% |
| 25 | 2050 | 4.5% |
| 27 | 1976 | 4.3% |
| 28 | 1965 | 4.3% |
| 29 | 1956 | 4.3% |
| 19 | 1824 | 4.0% |
| 15 | 1810 | 4.0% |
| 18 | 1765 | 3.9% |
| 16 | 1706 | 3.7% |
| 17 | 1696 | 3.7% |
| Other values (35) | 26722 |
| Value | Count | Frequency (%) |
| 10 | 750 | |
| 11 | 757 | |
| 12 | 746 | |
| 13 | 716 | 1.6% |
| 14 | 739 | |
| 15 | 1810 | |
| 16 | 1706 | |
| 17 | 1696 | |
| 18 | 1765 | |
| 19 | 1824 |
| Value | Count | Frequency (%) |
| 54 | 91 | 0.2% |
| 53 | 100 | 0.2% |
| 52 | 79 | 0.2% |
| 51 | 94 | 0.2% |
| 50 | 72 | 0.2% |
| 49 | 280 | |
| 48 | 277 | |
| 47 | 295 | |
| 46 | 274 | |
| 45 | 241 |
Interactions
Correlations
| City | Delivery_location_latitude | Delivery_location_longitude | Delivery_person_Age | Delivery_person_Ratings | Road_traffic_density | Temperature | Time_taken | Traffic_Index | Type_of_vehicle | Vehicle_condition | Weatherconditions | multiple_deliveries | translogi_latitude | translogi_longitude | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| City | 1.000 | 0.001 | 0.001 | 0.062 | 0.049 | 0.075 | 0.057 | 0.278 | 0.139 | 0.036 | 0.063 | 0.037 | 0.130 | 0.000 | 0.004 |
| Delivery_location_latitude | 0.001 | 1.000 | 0.122 | 0.004 | -0.010 | 0.018 | -0.003 | 0.030 | 0.030 | 0.011 | 0.000 | 0.000 | 0.009 | 0.973 | 0.116 |
| Delivery_location_longitude | 0.001 | 0.122 | 1.000 | 0.008 | -0.008 | 0.001 | 0.001 | 0.028 | 0.024 | 0.009 | 0.000 | 0.000 | 0.004 | 0.111 | 0.988 |
| Delivery_person_Age | 0.062 | 0.004 | 0.008 | 1.000 | -0.096 | 0.000 | 0.008 | 0.311 | 0.133 | 0.243 | 0.577 | 0.007 | 0.079 | 0.003 | 0.006 |
| Delivery_person_Ratings | 0.049 | -0.010 | -0.008 | -0.096 | 1.000 | 0.078 | 0.035 | -0.294 | -0.149 | 0.247 | 0.582 | 0.082 | 0.091 | -0.007 | -0.004 |
| Road_traffic_density | 0.075 | 0.018 | 0.001 | 0.000 | 0.078 | 1.000 | 0.506 | 0.265 | 0.574 | 0.000 | 0.006 | 0.000 | 0.109 | 0.006 | 0.002 |
| Temperature | 0.057 | -0.003 | 0.001 | 0.008 | 0.035 | 0.506 | 1.000 | -0.227 | -0.262 | 0.067 | 0.175 | 0.799 | 0.087 | -0.002 | 0.003 |
| Time_taken | 0.278 | 0.030 | 0.028 | 0.311 | -0.294 | 0.265 | -0.227 | 1.000 | 0.661 | 0.105 | 0.182 | 0.139 | 0.337 | 0.015 | 0.009 |
| Traffic_Index | 0.139 | 0.030 | 0.024 | 0.133 | -0.149 | 0.574 | -0.262 | 0.661 | 1.000 | 0.076 | 0.235 | 0.093 | 0.196 | 0.020 | 0.011 |
| Type_of_vehicle | 0.036 | 0.011 | 0.009 | 0.243 | 0.247 | 0.000 | 0.067 | 0.105 | 0.076 | 1.000 | 0.457 | 0.000 | 0.047 | 0.065 | 0.109 |
| Vehicle_condition | 0.063 | 0.000 | 0.000 | 0.577 | 0.582 | 0.006 | 0.175 | 0.182 | 0.235 | 0.457 | 1.000 | 0.000 | 0.075 | 0.164 | 0.251 |
| Weatherconditions | 0.037 | 0.000 | 0.000 | 0.007 | 0.082 | 0.000 | 0.799 | 0.139 | 0.093 | 0.000 | 0.000 | 1.000 | 0.068 | 0.000 | 0.000 |
| multiple_deliveries | 0.130 | 0.009 | 0.004 | 0.079 | 0.091 | 0.109 | 0.087 | 0.337 | 0.196 | 0.047 | 0.075 | 0.068 | 1.000 | 0.011 | 0.000 |
| translogi_latitude | 0.000 | 0.973 | 0.111 | 0.003 | -0.007 | 0.006 | -0.002 | 0.015 | 0.020 | 0.065 | 0.164 | 0.000 | 0.011 | 1.000 | 0.122 |
| translogi_longitude | 0.004 | 0.116 | 0.988 | 0.006 | -0.004 | 0.002 | 0.003 | 0.009 | 0.011 | 0.109 | 0.251 | 0.000 | 0.000 | 0.122 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| ID | Delivery_person_Age | Delivery_person_Ratings | translogi_latitude | translogi_longitude | Delivery_location_latitude | Delivery_location_longitude | Order_Date | Time_Orderd | Weatherconditions | Road_traffic_density | Vehicle_condition | Type_of_vehicle | multiple_deliveries | City | Temperature | Traffic_Index | Time_taken | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0x4607 | 37.0 | 4.9 | 22.745049 | 75.892471 | 22.765049 | 75.912471 | 2022-03-19 | 11:30:00 | Sunny | High | 2 | motorcycle | 0.0 | Urban | 29.0 | 1.200000 | 24 |
| 1 | 0xb379 | 34.0 | 4.5 | 12.913041 | 77.683237 | 13.043041 | 77.813237 | 2022-03-25 | 19:45:00 | Stormy | Jam | 2 | scooter | 1.0 | Metropolitian | 20.0 | 2.200000 | 33 |
| 2 | 0x5d6d | 23.0 | 4.4 | 12.914264 | 77.678400 | 12.924264 | 77.688400 | 2022-03-19 | 08:30:00 | Sandstorms | Low | 0 | motorcycle | 1.0 | Urban | 36.0 | 0.433333 | 26 |
| 3 | 0x7a6a | 38.0 | 4.7 | 11.003669 | 76.976494 | 11.053669 | 77.026494 | 2022-04-05 | 18:00:00 | Sunny | Medium | 0 | motorcycle | 1.0 | Metropolitian | 30.0 | 0.700000 | 21 |
| 4 | 0x70a2 | 32.0 | 4.6 | 12.972793 | 80.249982 | 13.012793 | 80.289982 | 2022-03-26 | 13:30:00 | Cloudy | High | 1 | scooter | 1.0 | Metropolitian | 24.0 | 3.000000 | 30 |
| 5 | 0x9bb4 | 22.0 | 4.8 | 17.431668 | 78.408321 | 17.461668 | 78.438321 | 2022-03-11 | 21:20:00 | Cloudy | Jam | 0 | motorcycle | 1.0 | Urban | 23.0 | 1.733333 | 26 |
| 6 | 0x95b4 | 33.0 | 4.7 | 23.369746 | 85.339820 | 23.479746 | 85.449820 | 2022-03-04 | 19:15:00 | Fog | Jam | 1 | scooter | 1.0 | Metropolitian | 16.0 | 5.333333 | 40 |
| 7 | 0x9eb2 | 35.0 | 4.6 | 12.352058 | 76.606650 | 12.482058 | 76.736650 | 2022-03-14 | 17:25:00 | Cloudy | Medium | 2 | motorcycle | 1.0 | Metropolitian | 25.0 | 1.066667 | 32 |
| 8 | 0x1102 | 22.0 | 4.8 | 17.433809 | 78.386744 | 17.563809 | 78.516744 | 2022-03-20 | 20:55:00 | Stormy | Jam | 0 | motorcycle | 1.0 | Metropolitian | 20.0 | 2.266667 | 34 |
| 9 | 0xcdcd | 36.0 | 4.2 | 30.327968 | 78.046106 | 30.397968 | 78.116106 | 2022-02-12 | 21:55:00 | Fog | Jam | 2 | motorcycle | 3.0 | Metropolitian | 16.0 | 3.066667 | 46 |
| ID | Delivery_person_Age | Delivery_person_Ratings | translogi_latitude | translogi_longitude | Delivery_location_latitude | Delivery_location_longitude | Order_Date | Time_Orderd | Weatherconditions | Road_traffic_density | Vehicle_condition | Type_of_vehicle | multiple_deliveries | City | Temperature | Traffic_Index | Time_taken | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45583 | 0x5193 | 36.0 | 4.8 | 12.310972 | 76.659264 | 12.440972 | 76.789264 | 2022-03-18 | 21:10:00 | Sunny | Jam | 2 | electric_scooter | 1.0 | Urban | 28.0 | 1.933333 | 29 |
| 45584 | 0xa333 | 37.0 | 4.8 | 13.022394 | 80.242439 | 13.042394 | 80.262439 | 2022-04-05 | 09:35:00 | Sandstorms | Low | 2 | electric_scooter | 0.0 | Metropolitian | 36.0 | 0.333333 | 20 |
| 45585 | 0xc9ab | 30.0 | 4.2 | 26.469003 | 80.316344 | 26.539003 | 80.386344 | 2022-02-14 | 18:10:00 | Cloudy | Medium | 1 | motorcycle | 2.0 | Metropolitian | 25.0 | 2.800000 | 42 |
| 45586 | 0x4e21 | 28.0 | 4.9 | 13.029198 | 77.570997 | 13.059198 | 77.600997 | 2022-03-30 | 21:55:00 | Sandstorms | Jam | 1 | scooter | 1.0 | Metropolitian | 33.0 | 3.866667 | 29 |
| 45587 | 0x1178 | 35.0 | 4.2 | 23.371292 | 85.327872 | 23.481292 | 85.437872 | 2022-03-08 | 21:45:00 | Windy | Jam | 2 | motorcycle | 1.0 | Metropolitian | 18.0 | 2.200000 | 33 |
| 45588 | 0x7c09 | 30.0 | 4.8 | 26.902328 | 75.794257 | 26.912328 | 75.804257 | 2022-03-24 | 11:35:00 | Windy | High | 1 | motorcycle | 0.0 | Metropolitian | 19.0 | 3.200000 | 32 |
| 45589 | 0xd641 | 21.0 | 4.6 | 0.000000 | 0.000000 | 0.070000 | 0.070000 | 2022-02-16 | 19:55:00 | Windy | Jam | 0 | motorcycle | 1.0 | Metropolitian | 18.0 | 2.400000 | 36 |
| 45590 | 0x4f8d | 30.0 | 4.9 | 13.022394 | 80.242439 | 13.052394 | 80.272439 | 2022-03-11 | 23:50:00 | Cloudy | Low | 1 | scooter | 0.0 | Metropolitian | 26.0 | 0.533333 | 16 |
| 45591 | 0x5eee | 20.0 | 4.7 | 11.001753 | 76.986241 | 11.041753 | 77.026241 | 2022-03-07 | 13:35:00 | Cloudy | High | 0 | motorcycle | 1.0 | Metropolitian | 24.0 | 1.300000 | 26 |
| 45592 | 0x5fb2 | 23.0 | 4.9 | 23.351058 | 85.325731 | 23.431058 | 85.405731 | 2022-03-02 | 17:10:00 | Fog | Medium | 2 | scooter | 1.0 | Metropolitian | 18.0 | 1.200000 | 36 |